Requirement already satisfied: sklearn in ./venv/lib/python3.10/site-packages (0.0.post1) [notice] A new release of pip available: 22.2.2 -> 23.0.1 [notice] To update, run: pip install --upgrade pip
Requirement already satisfied: squarify in ./venv/lib/python3.10/site-packages (0.4.3) [notice] A new release of pip available: 22.2.2 -> 23.0.1 [notice] To update, run: pip install --upgrade pip
/home/ayush/Documents/Project/ayush/customer_segm_RFM
| Unnamed: 0 | InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | len | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-12-01 08:26:00 | 2.55 | 17850.0 | United Kingdom | 34 |
| 1 | 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 19 |
| 2 | 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 2010-12-01 08:26:00 | 2.75 | 17850.0 | United Kingdom | 30 |
| 3 | 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 35 |
| 4 | 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 30 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 244420 | 245898 | 558637 | 22032 | BOTANICAL LILY GREETING CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 |
| 244421 | 245899 | 558637 | 22028 | PENNY FARTHING BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 |
| 244422 | 245900 | 558637 | 22033 | BOTANICAL ROSE GREETING CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 |
| 244423 | 245901 | 558637 | 22029 | SPACEBOY BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 22 |
| 244424 | 245902 | 558637 | 22024 | RAINY LADIES BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 26 |
244425 rows × 10 columns
Timestamp('2011-06-30 20:07:00')
Unnamed: 0 int64 InvoiceNo object StockCode object Description object Quantity int64 InvoiceDate datetime64[ns] UnitPrice float64 CustomerID float64 Country object len int64 dtype: object
2011-12-10 00:00:00
| Unnamed: 0 | InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | len | TotalSum | Frequency | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-12-01 08:26:00 | 2.55 | 17850.0 | United Kingdom | 34 | 15.30 | 373 days 15:34:00 |
| 1 | 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 19 | 20.34 | 373 days 15:34:00 |
| 2 | 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 2010-12-01 08:26:00 | 2.75 | 17850.0 | United Kingdom | 30 | 22.00 | 373 days 15:34:00 |
| 3 | 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 35 | 20.34 | 373 days 15:34:00 |
| 4 | 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 30 | 20.34 | 373 days 15:34:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 244420 | 245898 | 558637 | 22032 | BOTANICAL LILY GREETING CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 | 5.04 | 162 days 03:53:00 |
| 244421 | 245899 | 558637 | 22028 | PENNY FARTHING BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 | 5.04 | 162 days 03:53:00 |
| 244422 | 245900 | 558637 | 22033 | BOTANICAL ROSE GREETING CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 28 | 5.04 | 162 days 03:53:00 |
| 244423 | 245901 | 558637 | 22029 | SPACEBOY BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 22 | 5.04 | 162 days 03:53:00 |
| 244424 | 245902 | 558637 | 22024 | RAINY LADIES BIRTHDAY CARD | 12 | 2011-06-30 20:07:00 | 0.42 | 17891.0 | United Kingdom | 26 | 5.04 | 162 days 03:53:00 |
244425 rows × 12 columns
Reference Date: 2011-12-10 00:00:00
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| CustomerID | 3002.0 | 15300.995670 | 1720.020920 | 12346.0 | 13817.5 | 15263.5 | 16779.75 | 18287.0 |
| recency | 3002.0 | 232.783145 | 60.930992 | 162.0 | 183.0 | 213.0 | 271.00 | 373.0 |
| CustomerID | recency | |
|---|---|---|
| 0 | 12346.0 | 325.0 |
| 1 | 12347.0 | 183.0 |
| 2 | 12348.0 | 248.0 |
| 3 | 12350.0 | 310.0 |
| 4 | 12352.0 | 262.0 |
| ... | ... | ... |
| 2997 | 18277.0 | 318.0 |
| 2998 | 18280.0 | 277.0 |
| 2999 | 18281.0 | 180.0 |
| 3000 | 18283.0 | 169.0 |
| 3001 | 18287.0 | 201.0 |
3002 rows × 2 columns
| CustomerID | recency | frequency | TotalSum | |
|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 |
| 1 | 12347.0 | 183.0 | 4 | 2205.95 |
| 2 | 12348.0 | 248.0 | 3 | 1487.24 |
| 3 | 12350.0 | 310.0 | 1 | 334.40 |
| 4 | 12352.0 | 262.0 | 8 | 601.18 |
| ... | ... | ... | ... | ... |
| 2997 | 18277.0 | 318.0 | 1 | -12.75 |
| 2998 | 18280.0 | 277.0 | 1 | 180.60 |
| 2999 | 18281.0 | 180.0 | 1 | 80.82 |
| 3000 | 18283.0 | 169.0 | 7 | 842.58 |
| 3001 | 18287.0 | 201.0 | 1 | 765.28 |
3002 rows × 4 columns
CustomerID 0 Recency 0 Frequency 0 Monetary 0 dtype: int64
| CustomerID | Recency | Frequency | Monetary | |
|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 |
| 1 | 12347.0 | 183.0 | 4 | 2205.95 |
| 2 | 12348.0 | 248.0 | 3 | 1487.24 |
| 3 | 12350.0 | 310.0 | 1 | 334.40 |
| 4 | 12352.0 | 262.0 | 8 | 601.18 |
| ... | ... | ... | ... | ... |
| 2997 | 18277.0 | 318.0 | 1 | -12.75 |
| 2998 | 18280.0 | 277.0 | 1 | 180.60 |
| 2999 | 18281.0 | 180.0 | 1 | 80.82 |
| 3000 | 18283.0 | 169.0 | 7 | 842.58 |
| 3001 | 18287.0 | 201.0 | 1 | 765.28 |
3002 rows × 4 columns
| CustomerID | Recency | Frequency | Monetary | R | F | M | |
|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 |
| 1 | 12347.0 | 183.0 | 4 | 2205.95 | 4 | 3 | 4 |
| 2 | 12348.0 | 248.0 | 3 | 1487.24 | 2 | 3 | 4 |
| 3 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 |
| 4 | 12352.0 | 262.0 | 8 | 601.18 | 2 | 4 | 3 |
| CustomerID | Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | |
|---|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 | 1.02.01.0 |
| 1 | 12347.0 | 183.0 | 4 | 2205.95 | 4 | 3 | 4 | 4.03.04.0 |
| 2 | 12348.0 | 248.0 | 3 | 1487.24 | 2 | 3 | 4 | 2.03.04.0 |
| 3 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 | 1.01.02.0 |
| 4 | 12352.0 | 262.0 | 8 | 601.18 | 2 | 4 | 3 | 2.04.03.0 |
64 0 4 1 11 2 9 3 4 4 9 Name: RFM_Score, dtype: int64
| CustomerID | Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | RFM_Score | RFM_Level | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 | 1.02.01.0 | 4 | Requires Attention |
| 1 | 12347.0 | 183.0 | 4 | 2205.95 | 4 | 3 | 4 | 4.03.04.0 | 11 | Can't Loose Them |
| 2 | 12348.0 | 248.0 | 3 | 1487.24 | 2 | 3 | 4 | 2.03.04.0 | 9 | Can't Loose Them |
| 3 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 | 1.01.02.0 | 4 | Requires Attention |
| 4 | 12352.0 | 262.0 | 8 | 601.18 | 2 | 4 | 3 | 2.04.03.0 | 9 | Can't Loose Them |
| 5 | 12353.0 | 204.0 | 1 | 89.00 | 3 | 1 | 1 | 3.01.01.0 | 5 | Promising |
| 6 | 12354.0 | 232.0 | 1 | 1079.40 | 2 | 1 | 3 | 2.01.03.0 | 6 | Potential |
| 7 | 12355.0 | 214.0 | 1 | 459.40 | 2 | 1 | 2 | 2.01.02.0 | 5 | Promising |
| 8 | 12356.0 | 245.0 | 2 | 2753.08 | 2 | 2 | 4 | 2.02.04.0 | 8 | Champions |
| 9 | 12359.0 | 189.0 | 4 | 3459.93 | 3 | 3 | 4 | 3.03.04.0 | 10 | Can't Loose Them |
| 10 | 12360.0 | 200.0 | 1 | 1083.58 | 3 | 1 | 3 | 3.01.03.0 | 7 | Loyal/Commited |
| 11 | 12361.0 | 287.0 | 1 | 189.90 | 1 | 1 | 1 | 1.01.01.0 | 3 | Demands Activation |
| 12 | 12362.0 | 225.0 | 3 | 969.44 | 2 | 3 | 3 | 2.03.03.0 | 8 | Champions |
| 13 | 12363.0 | 242.0 | 1 | 299.10 | 2 | 1 | 2 | 2.01.02.0 | 5 | Promising |
| 14 | 12365.0 | 291.0 | 3 | 320.69 | 1 | 3 | 2 | 1.03.02.0 | 6 | Potential |
Recency Frequency Monetary
mean mean mean count
RFM_Level
Can't Loose Them 187.3 6.8 2642.2 1150
Champions 217.3 2.4 713.5 306
Demands Activation 329.4 1.0 113.2 189
Loyal/Commited 226.4 1.9 486.9 305
Potential 244.5 1.5 387.0 369
Promising 269.2 1.2 273.1 347
Requires Attention 303.7 1.1 190.8 336
